2016-11-09 - 28351 - Enhancement - COPA changes #FinanceControlling
SPECIFICATIONS
28351- Copa Changes
Purpose
Need to enhance the COPA source & related BEx Queries with new requested changes from business
Admin Info
Purpose
|
Need to enhance the COPA source & related BEx Queries with the new requested changes from business.
|
Requested By
|
John Thompson
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
11-09-2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZCOPA_C03 & BEx Queries for all regions where COPA source is included
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
16
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
120
|
4
|
Unit test in DEV
|
16
|
5
|
Unit test in QUA
|
08
|
6
|
Other activity
|
12
|
|
TOTAL
|
180
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Need to change the descriptions & logic in COPA infocube
|
Jinghsa Brennan
|
01/12/2017
|
Through EMail
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Jingsha on 04-10-2016:
Dear BI team,
You might have heard about from Mark and here are the updated BI requirements for Rebates and Split discounts. Please do not hesitate to ask me for any further questions.
1) Rebate, Standard Discount and Other discount should all be available to view in Analysis or Webi.
2) Standard discount , other discount and Rebate should roll up to “Total Discount” ( replacing the current Sales Discount)
3) The rest of the existing calculated fields such as Net Sales (Gross Revenue-Total Discount), gross profit, contribution margin etc. should be updated automatically.
4) As of now, no further requirements are needed to show Rebates or different discounts separately in Crystal Reports. Sheila/Deb/Dan and Mike all said they do not use Crystal SA reports, and they said that most likely the regions do not use the reports neither. However, if Crystal Reports shows “Discount”, then this discount should be the Total discount, which is composed by standard discount, other discount and rebate. Is there a way we can check the system log and find out who used the reports?
5) When taking Open order into consideration, here are the discount types and their map to either the “Standard Discount” or “Other Discounts”
- a. Standard Discount, mapped to VV0003, condition type Z020
- b. All other discounts will be mapped to RABAT, including below condition types
i. Z021
ii. Z031
iii. ZDOR
iv. Z032
v. Z0DD
vi. Z0MD
In terms of the fields, now that we try to avoid using VV022, here is my proposal:
VV008 – Customer Rebate is currently available in COPA source, but data is not populated. This will be populated after Rebate is implemented.
VV003 – Change to “Standard Discount”
RABAT – Keep as “Other discounts”
I also realized that I will be making some changes to some of the existing Manual revenue fields. Those are most likely being passed into BW, but not sure whether we include them in any query. Here are the fields:
VV013 Revenue-Manual Adjus
VV014 Rev. Red.-Manual Adj
Email from Jingsha on 01/12/2017:
We found some issues during testing. Here are the changes that we will need to make.
1) Customer Rebate (VV008) and Other Discounts (RABAT) should have the sign flipped just like Standard Discount (VV003)
2) Rev. Red.-Manual Adj (VV014) should have the sign flipped
3) Going forward, gross revenue is not only ERLOS, but should take the new two manual revenue fields into consideration, then should be ERLOS+VV013+VV014(after flipping the sign). This change should impact all fields that indicates Total Revenue or total sales (Gross, net, etc.)
In Scope:
Condition Source
Out of Scope:
None
Solution Summary
1. Need to check if all the requested fields are mapped correctly from COPA datasource in transformations.
2. Need to change the CKF formulas in all the sales analysis BEx Queries as requested.
3. Need to include Shipped Discounts, Customer Rebate & other discounts in all the Analysis BEx Queries.
4. Need to unit test the changes in BPD & BPQ.
5. Need to collect all the changes into the transport requests.
Changes on 01/12/2017
1. Need to flip the sign of customer rebate, revenue red manual adjustment & Other discounts in COPA infocube.
2. Need to change the gross revenue formula in all the CKF's wherever needed.
3. Need to update the changes in all the Analysis BEx Queries.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Need to test if validation went successful for all the enhanced fields.
|
Validation should be successful for all the enhanced fields.
|
2
|
Need to check if all the Analysis Queries are updated with the requested fields.
|
All the Analysis Queries should be updated with requested fields.
|
Solution Details
1. Checked if all the requested fields are mapped correctly from COPA datasource in transformations.
2. Changed all the CKF formulas in the sales analysis BEx Queries as requested.
3. Included Shipped Discounts(Z_DISCGR), Customer Rebate(Z_CUSTREB) & other discounts(Z_OTHDISC) in all the Analysis BEx Queries.
4. Unit tested the changes in BPD & BPQ.
Changes on 01/12/2017
1. Flipped the sign of customer rebate Z_CUSTREB, revenue red manual adjustment Z_VV014 & Other discounts Z_OTHDISC in COPA infocube.
2. Changed the gross revenue formula in all the CKF's wherever needed.
3. Updated the changes in all the Analysis BEx Queries.
Issues
As BPQ System is locked for HANA upgrade, the transport path is set to move from BD1(Copy of BPD) to BPP.